package com.googlecode.stockhamster;

public class Constant {
	public static final String statusAdminCode = "status_code";
	public static final String bankAdminCode = "bank_code";
	public static final String marketAdminCode = "market_code";
	public static final String rumorAdminCode = "rumor_code";
	public static final String companyAdminCode = "company_code";

	public static final String arbiterUrl = "http://59.66.131.45:8080/Hamster/services/Arbiter";
	public static final String bankUrl = "http://59.66.131.45:8080/Hamster/services/Bank";
	public static final String stockMarketUrl = "http://59.66.131.45:8080/Hamster/services/StockMarket";
	public static final String stockStatUrl = "http://59.66.131.45:8080/Hamster/services/StockStat";
	public static final String rumorUrl = "http://59.66.131.45:8080/Hamster/services/Rumor";
	public static final String companyUrl = "http://59.66.131.45:8080/Hamster/services/Company";
	public static final String expertUrl = "http://59.66.131.45:8080/Hamster/services/Expert";

	public static final String dbDir = "D:/pzh/db/";

	public static final String dbArbiter = "arbiter";
	public static final String abiterAccount = "ArbiterAccount";
	public static final String abiterAccountItems = " username varchar(64), password varchar(64), bankcode varchar(64), stockcode varchar(64) ";

	public static final String dbBank = "bank";
	public static final String bankAccount = "BankAccount";
	public static final String bankAccountItems = " username varchar(64), bankcode varchar(64), money bigint ";
	public static final String bankCheck = "BankCheck";
	public static final String bankCheckItems = " username varchar(64), moneycode varchar(64), money bigint ";
	
	public static final String dbStockMarket = "StockMarket";
	public static final String stockAccount = "StockAccount";
	public static final String stockAccountItems = " username varchar(64), code varchar(64) ";
	public static final String stockAccountStock = "StockAccountStock";
	public static final String stockAccountStockItems = " username varchar(64), stockID bigint, amount bigint, ID identity ";
	public static final String stockTradeItem = "StockTradeItems";
	public static final String stockTradeItemItems = " isBuy boolean, username varchar(64), stockID integer, price bigint, amount integer, moneyCode varchar(64), ID identity ";
	
	public static final String dbStockStat = "Stockstat";
	public static final String stock = "Stock";
	public static final String stockItems = " ID identity, name varchar(64), category varchar(64), price bigint, limited boolean ";
	public static final String stockHistory = "StockHistory";
	public static final String stockHistoryItems = " stockID integer, price bigint, volumes bigint, time Datetime, ID identity";
	
	public static final String dbRumor = "rumor";
	public static final String rumor = "Rumor";
	public static final String rumorItems = " effectCategory varchar(64), effectCompany varchar(64), effectRatio double, ratio1 double, ratio2 double, ratio3 double, ID identity ";
	public static final String rumorIncRatio = "rumorIncRatio";
	public static final String rumorIncRatioItems = " companyName varchar(64), category varchar(64), ratio1 double, ratio2 double, ratio3 double ";
	
	public static final String dbCompany = "company";
	public static final String company = "Company";

	public static final String companyItems = " companyName varchar(64), bankCode varchar(64), stockCode varchar(64), category varchar(64), incRate double, stockID integer, issueSize integer ";
	
	public static final String pathFileCSV = "D:/Java/workspace/Hamster/test.csv";
	public static final String companyListCSV = "D:/Java/workspace/Hamster/company.csv";
	public static final Long aiInitialBalance = 100000000L;
}
